create external table jms_dm.dm_false_send_xyf_detail_dt (
     waybill_no                    string         comment'运单编号'
    ,ordersource_code              string         comment'订单来源编码'
    ,ordersource_name              string         comment'订单来源名称'
    ,start_network_code            string         comment'始发网点编码'
    ,start_network_name            string         comment'始发网点名称'
    ,start_agent_code              string         comment'始发代理区编码'
    ,start_agent_name              string         comment'始发代理区名称'
    ,start_virt_code               string         comment'始发虚拟代理区编码'
    ,start_virt_name               string         comment'始发虚拟代理区名称'
    ,start_provider_id             string         comment'始发省份编码'
    ,start_provider_desc           string         comment'始发省份名称'
    ,start_city_id                 string         comment'始发城市编码'
    ,start_city_desc               string         comment'始发城市名称'
    ,start_center_code             string         comment'始发中心编码'
    ,start_center_name             string         comment'始发中心名称'
    ,taking_time                   timestamp      comment'揽收时间'
    ,network_send_time             timestamp      comment'始发网点发件时间'
    ,start_center_arrival_time     timestamp      comment'始发中心到件时间'
    ,start_center_send_time        timestamp      comment'始发中心发件时间'
    ,customer_order_time           timestamp      comment'客户下单时间'
    ,is_upload_flag                bigint         comment'是否手动补录'
    ,upload_batch                  string         comment'批次号'
) comment '逍遥峰虚假发货明细'
partitioned by (dt string comment '分区日期')
stored as parquet
location '/dw/hive/jms_dm.db/external/dm_false_send_xyf_detail_dt'
tblproperties (
'discover.partitions'='false' ,
'parquet.column.index.access'='true'
);